Oracle BI Discoverer Review
We use Oracle Business Intelligence Discoverer as part of ERP for our purchasing and financial reports.
Overview
What is Oracle Discoverer (discontinued)?
Oracle's Business Intelligence Discoverer is an ad- hoc query and analysis reporting tool oriented for end users to have easy access to relational and multi-dimensional data. The product is now end of life. The vendor has stated that Discoverer 11g…
Recent Reviews
Popular Features
- Multi-User Support (named login) (22)10.0100%
- Report Delivery Scheduling (22)8.080%
- Formatting capabilities (22)8.080%
- Drill-down analysis (21)7.070%
Pricing
N/A
Unavailable
What is Oracle Discoverer (discontinued)?
Oracle's Business Intelligence Discoverer is an ad- hoc query and analysis reporting tool oriented for end users to have easy access to relational and multi-dimensional data. The product is now end of life. The vendor has stated that Discoverer 11g release 11.1.1.7.0 is the terminal release of…
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
3 people also want pricing
Alternatives Pricing
What is Microsoft Power BI?
Microsoft Power BI is a visualization and data discovery tool from Microsoft. It allows users to convert data into visuals and graphics, visually explore and analyze data, collaborate on interactive dashboards and reports, and scale across their organization with built-in governance and security.
What is Spotfire?
Spotfire® is a data visualization platform that utilizes predictive analytics. In addition to data viz, it includes data wrangling capabilities, predictive analytics, location analytics, and real-time streaming analytics. Spotfire® is a business unit of Cloud Software Group, formerly known as…
Features
Return to navigation
Product Details
- About
- Competitors
- Tech Details
- FAQs
What is Oracle Discoverer (discontinued)?
Oracle's Business Intelligence Discoverer is an ad- hoc query and analysis reporting tool oriented for end users to have easy access to relational and multi-dimensional data. The product is now end of life. The vendor has stated that Discoverer 11g release 11.1.1.7.0 is the terminal release of Discoverer.
Oracle Discoverer (discontinued) Competitors
- Tableau Desktop
- Microsoft
- IBM
Oracle Discoverer (discontinued) Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Frequently Asked Questions
Oracle's Business Intelligence Discoverer is an ad- hoc query and analysis reporting tool oriented for end users to have easy access to relational and multi-dimensional data. The product is now end of life. The vendor has stated that Discoverer 11g release 11.1.1.7.0 is the terminal release of Discoverer.
Tableau Desktop are common alternatives for Oracle Discoverer (discontinued).
Reviewers rate Multi-User Support (named login) and Role-Based Security Model and Single Sign-On (SSO) highest, with a score of 10.
The most common users of Oracle Discoverer (discontinued) are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(635)Attribute Ratings
Reviews
(1-7 of 7)Companies can't remove reviews or game the system. Here's why
Business Intelligence Discoverer is used to access and analyze data in the database and create reports. Since it supports web-based publishing of reports, it serves as a single tool to query, analyze, report and publish it in the web. It is a very useful tool for non-technical or business analysts.
It is used only by a department and not across the organization.
It addresses the business problem of getting immediate access to data and analyze data in the database and create reports.
It is used only by a department and not across the organization.
It addresses the business problem of getting immediate access to data and analyze data in the database and create reports.
- Querying database, analyzing the data using data models
- Reporting and publishing on the web
- Integrates with Oracle Portal, Oracle WebCenter, and Oracle WebLogic Portal
- Tools look classic, more intuitive UI would be good
- Even though non-technical users can use it, relational data model creation needs technical knowledge
- Not a regular self-guiding reporting tool, needs training
November 04, 2019
Browser-based tool for your simple data needs.
The Oracle Business Intelligence (BI) Discoverer is used by teams across the entire organisation for easy access to data and actionable-information in their day to day activities. For example, teams from the Marketing division use BI Discoverer to retrieve data that helps make decisions for running promotions. There are similar use cases for the Operations and Finance divisions as well.
- Browser-based access makes it easy for users.
- Provides all basic techniques for data analytics.
- It is easy to collaborate with other users on certain dashboards.
- Performance takes a hit when working with large databases.
- Limited features for visualisation.
- Use of RPDs are limited as well.
October 25, 2019
Oracle BI Discoverer - Your one stop solution to enterprise reporting and analytics!!!
The BI Discoverer is being used by our Finance/HR and Payroll departments. A lot of instant mission-critical reports are being generated from the Oracle EBS system via discoverer. It has really helped the users with time-savings.
- Complex reporting made easy.
- With ease, multiple levels of nested groupings possible within pivot functionality.
- A lot of formatting tools are available for more control of reports containing visual attributes.
- Maybe a more user-friendly worksheet wizard used in this tool.
- More tuning options or maybe SQL advisory hints when building the worksheets would be immensely helpful.
September 16, 2019
Business Intelligence Discoverer and OBIEE
Business Intelligence Discoverer is being used agency wide. Our entire company supports our clients in the use and development of financial reports in it as well as the migration to Oracle Business Intelligence Enterprise Edition (OBIEE). The lack of visualization and ability to have the average users create reports is forcing our clients to look at alternative options. However, the seamless migration bath to OBIEE has helped us continue supporting our clients by delivering new and enhanced reports much faster than a full blown migration to a new product.
- Detailed report generation
- Drag and drop report creation
- Exporting data for integration with other tools
- Visualization
- Star Schema Integration with different tables
December 12, 2018
Discover your data with Discoverer!
Discoverer is a great reporting tool and currently we use it across the organization but divided by business units - each business unit within the organization has their own setup for Discoverer. Discoverer puts great control in the hands of the end users. We divided user groups into Super Users and Consumers. Super Users of that group understand the data and create reports. Consumers will consume the reports and make a decision accordingly.
- Discoverer puts the control in end-user hands. Super Users, who have privileges to create reports, can create and test SQL Queries in SQL Developer and then use the Custom SQL option in Discoverer to create a report based on that SQL. This means the user doesn't have to run the query every day manually, but the report is ready whenever they want to access it.
- Discoverer eliminates the costly developer layer. Super Users are business users who can create reports for their team on their own. This means there is no need for developers or explaining to them how to use the data.
- Discoverer consolidates the tables into business areas. Each business area can serve a specific set of users within a department. This helps make the management of reports and data easy.
- Duplication of data. While Discoverer supports business areas, it allows a lot of duplication. The same table can exist in multiple business areas. Similar queries and reports exist in multiple places. As multiple Super Users exist in each business area, there are high chances of duplication and increased storage cost.
- OPatch doesn't work well with Discoverer. Patching Discoverer is a pain. OPatch may not be applicable in all scenarios.
- No direct path to upgrade Discoverer to OBIEE 12c. If an organization decides to upgrade their Discoverer to OBIEE12c, there is no direct path. They have to upgrade to OBIEE 11g and then to 12c, and even that process is flawed. As mentioned earlier, the duplication of business areas in each End User Layer may create a messy OBIEE RPD with a lot of duplications. It is always advisable to launch a new OBIEE project rather than migrating from Discoverer.
- Lack of dashboards. Unlike other BI tools, Discoverer lacks a dashboard. However, we can build one on OAS, but it needs lot of customizations and integrations. Discoverer web interface is bad at managing cache. Users frequently complain about stale data.
December 07, 2018
Business Intelligence Discoverer, a relatively simple and straightforward BI solution
Business Intelligence Discoverer was used for some departments (majorly the BI department), the main focus user group is those who don't have enough in-depth SQL or let's say database knowledge. It's also only for those databases which don't have a complex relationship, and where the business user's graphic report requirement is quite straightforward. So, the end user can quickly transfer the info buried in the Oracle database to a more understandable chart and share with team members.
- It is good for quickly building some ad-hoc report on top of the data
- It works well with the Oracle's own database of course
- The drop feature is very useful for the business user who hasn't mastered the SQL knowledge
- Allow customization of PL/SQL functions/procedures, to add more complex data processing logic
- In order to be able to add the data "processing" logic, for the basic business user without too much SQL or procedure knowledge, it is almost mission impossible. Simply hiding the complexity of basic technical things like "join" is not enough.
- Lack of the "hints" or "relationship explanation" when a report with complex joins is created
- Data visualization options are really too limited
October 18, 2016
Discover the benefits of Discoverer
Business Intelligence Discoverer has been the key user self-service reporting tool against Oracle E-Business Suite. Empowering the application users to create and run their own reports by developing a robust reporting structure has enabled application users to get the data they need when they need it without waiting on requests to the IT department. Discoverer is also used by Audit and Tax to pull data to support filings and respond to data requests.
- Discoverer is a good tool for providing customer ad hoc reporting. The UI is clean and easy to use.
- Built in interfaces to Oracle applications seamlessly integrate reporting with application security and data access restrictions. Having a reporting environment that matches the OLTP system security simplifies compliance with various legal, regulatory, and business data access requirements.
- The ability to link data from one report to another and drill to detail provides detailed data analysis from high-level reports with exception reporting.
- Discoverer needs better data visualization options.
- I would like to see built in integration with SharePoint so published management reports can more easily be delivered to users.
- Mobile tools for both report delivery and system maintenance would enhance usability.